﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CI_ELEC_RPF.aspx.cs" Inherits="StreetSmartAdmin.CI_ELEC_RPF" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
        <style type="text/css">
        body
        {
        font-family:"Times New Roman";
        }

    </style>


</head>
<body>
    <form id="form1" runat="server">
    <div>

   <center>
    <img alt="" src="images/logo.jpg" style="height: 79px" />
    <h1>Request for Proposals</h1>
    <h2>For the Procurement of Electricity</h2>
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            
           SelectCommand="SELECT [COMPANY_NAME], [BUSINESS_TYPE], [TITLE], [FIRST_NAME], [LAST_NAME], [POSITION], [MOBILE], [BPHONE], [EMAIL], [NOTICE_ADDRESS], [NOTICE_SUBURB], [NOTICE_STATE], [NOTICE_POSTCODE], [ELEC_CURRENT_RETAILER], [ELEC_PRICE_TYPE], [ELEC_CARBON_PRICE_OPTION], [ELEC_CONTRACT_TERM], [ELEC_CONTRACT_START_DATE], [ELEC_CONTRACT_END_DATE], [ELEC_PRICE_COB], [ELEC_GREEN_ENERGY_REQUIREMENT], [ELEC_GREEN_ENERGY_PERCENT], [ELEC_DATA_PROVIDED], [BILL_ADDRESS], [BILL_SUBURB], [BILL_STATE], [BILL_POSTCODE] FROM [tblCI] WHERE ([USERID] = @USERID)">
            <SelectParameters>
                <asp:SessionParameter Name="USERID" SessionField="USERID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>" 
            SelectCommand="SELECT [SITE_NO], [SITE_NAME], [ABN], [ACN], [NMI], [ACCOUNT_NO], [PA_PK], [PA_SH], [PA_OP], [PA_TOTAL] FROM [tblCI_ELEC_SITE_DETAIL] WHERE ([USERID] = @USERID)">
            <SelectParameters>
                <asp:SessionParameter Name="USERID" SessionField="USERID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" 
            EnableModelValidation="True">

            <ItemTemplate>

            <table>
            <tr>
                <td>Company Name:
                </td>
                <td><asp:Label ID="COMPANY_NAMELabel" runat="server" 
                    Text='<%# Bind("COMPANY_NAME") %>' />
                </td>
            </tr>
            <tr>
                <td>Industry/Business Type:
                </td>
                <td>
                <asp:Label ID="BUSINESS_TYPELabel" runat="server" 
                    Text='<%# Bind("BUSINESS_TYPE") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Name:
                </td>
                <td><asp:Label ID="Label1" runat="server" Text='<%# Bind("TITLE") %>' />&nbsp;
                <asp:Label ID="FIRST_NAMELabel" runat="server" 
                    Text='<%# Bind("FIRST_NAME") %>' />&nbsp;
                <asp:Label ID="LAST_NAMELabel" runat="server" Text='<%# Bind("LAST_NAME") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Title:
                </td>
                <td><asp:Label ID="POSITIONLabel" runat="server" Text='<%# Bind("POSITION") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Phone(Mobile):
                </td>
                <td><asp:Label ID="MOBILELabel" runat="server" Text='<%# Bind("MOBILE") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Phone (direct):
                </td>
                <td><asp:Label ID="BPHONELabel" runat="server" Text='<%# Bind("BPHONE") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Email:
                </td>
                <td> <asp:Label ID="EMAILLabel" runat="server" Text='<%# Bind("EMAIL") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Notices Address:
                </td>
                <td><asp:Label ID="NOTICE_ADDRESSLabel" runat="server" 
                    Text='<%# Bind("NOTICE_ADDRESS") %>' />&nbsp;
                    <asp:Label ID="NOTICE_SUBURBLabel" runat="server" 
                    Text='<%# Bind("NOTICE_SUBURB") %>' />&nbsp;
                    <asp:Label ID="NOTICE_STATELabel" runat="server" 
                    Text='<%# Bind("NOTICE_STATE") %>' />&nbsp;
                    <asp:Label ID="NOTICE_POSTCODELabel" runat="server" 
                    Text='<%# Bind("NOTICE_POSTCODE") %>' />
                </td>
            </tr>
            <tr>
                <td>Contact Billing Address:
                </td>
                <td><asp:Label ID="Label2" runat="server" 
                    Text='<%# Bind("BILL_ADDRESS") %>' />&nbsp;
                    <asp:Label ID="Label3" runat="server" 
                    Text='<%# Bind("BILL_SUBURB") %>' />&nbsp;
                    <asp:Label ID="Label4" runat="server" 
                    Text='<%# Bind("BILL_STATE") %>' />&nbsp;
                    <asp:Label ID="Label5" runat="server" 
                    Text='<%# Bind("BILL_POSTCODE") %>' />
                </td>
            </tr>
            <tr>
                <td>Current Retailer:
                </td>
                <td><asp:Label ID="ELEC_CURRENT_RETAILERLabel" runat="server" 
                    Text='<%# Bind("ELEC_CURRENT_RETAILER") %>' />
                </td>
            </tr>
            <tr>
                <td>Price Type:
                </td>
                <td><asp:Label ID="ELEC_PRICE_TYPELabel" runat="server" 
                    Text='<%# Bind("ELEC_PRICE_TYPE") %>' />
                </td>
            </tr>
            <tr>
                <td>Carbon Pricing Options Required<br/>(If available)
                </td>
                <td>
                <asp:Label ID="ELEC_CARBON_PRICE_OPTIONLabel" runat="server" 
                    Text='<%# Bind("ELEC_CARBON_PRICE_OPTION") %>' />
                </td>
            </tr>
            <tr>
                <td>Contract Term:
                </td>
                <td>
                <asp:Label ID="ELEC_CONTRACT_TERMLabel" runat="server" 
                    Text='<%# Bind("ELEC_CONTRACT_TERM") %>' />
                </td>
            </tr>
            <tr>
                <td>Contract Start Date:
                </td>
                <td>
                <asp:Label ID="ELEC_CONTRACT_START_DATELabel" runat="server" 
                    Text='<%# Bind("ELEC_CONTRACT_START_DATE") %>' />
                </td>
            </tr>
            <tr>
                <td>Contract End Date:
                </td>
                <td>
                <asp:Label ID="ELEC_CONTRACT_END_DATELabel" runat="server" 
                    Text='<%# Bind("ELEC_CONTRACT_END_DATE") %>' />
                </td>
            </tr>
            <tr>
                <td>Price Required by COB:
                </td>
                <td>
                <asp:Label ID="ELEC_PRICE_COBLabel" runat="server" 
                    Text='<%# Bind("ELEC_PRICE_COB") %>' />
                </td>
            </tr>
            <tr>
                <td>Green Energy Required:
                </td>
                <td><asp:Label ID="ELEC_GREEN_ENERGY_REQUIREMENTLabel" runat="server" 
                    Text='<%# Bind("ELEC_GREEN_ENERGY_REQUIREMENT") %>' />
                </td>
            </tr>
            <tr>
                <td>% Green:
                </td>
                <td><asp:Label ID="ELEC_GREEN_ENERGY_PERCENTLabel" runat="server" 
                    Text='<%# Bind("ELEC_GREEN_ENERGY_PERCENT") %>' />
                </td>
            </tr>
            <tr>
                <td>½ Hourly Data Provided:
                </td>
                <td><asp:Label ID="ELEC_DATA_PROVIDEDLabel" runat="server" 
                    Text='<%# Bind("ELEC_DATA_PROVIDED") %>' />
                </td>
            </tr>

            </table>


            </ItemTemplate>
        </asp:FormView>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource2" EnableModelValidation="True">
            <Columns>
                <asp:BoundField DataField="SITE_NO" HeaderText="Site No." 
                    SortExpression="SITE_NO" />
                <asp:BoundField DataField="SITE_NAME" HeaderText="Site Name" 
                    SortExpression="SITE_NAME" />
                <asp:BoundField DataField="ABN" HeaderText="ABN" SortExpression="ABN" />
                <asp:BoundField DataField="ACN" HeaderText="ACN" SortExpression="ACN" />
                <asp:BoundField DataField="NMI" HeaderText="NMI" SortExpression="NMI" />
                <asp:BoundField DataField="ACCOUNT_NO" HeaderText="Account No." 
                    SortExpression="ACCOUNT_NO" />
                <asp:BoundField DataField="PA_PK" HeaderText="Peak" SortExpression="PA_PK" />
                <asp:BoundField DataField="PA_SH" HeaderText="Shoulder" SortExpression="PA_SH" />
                <asp:BoundField DataField="PA_OP" HeaderText="Off Peak" SortExpression="PA_OP" />
                <asp:BoundField DataField="PA_TOTAL" HeaderText="Total" 
                    SortExpression="PA_TOTAL" />
            </Columns>
        </asp:GridView>
        </center>
    </div>
    </form>
</body>
</html>
